2013-03-25 - 5910.200 - Rel Notes - Contracts - Release 015 #BIReleases2013
Release Notes:
5910.200 - Contracts - SA140
Admin Info
Purpose
|
Including Contract Information in SA140 report
|
Release No
|
015
|
Submitted
|
03-25-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Narendra K
|
Object(s) Tested By
|
Narendra K
|
Report Name
SA140 - License Scorecard
BEx Query
ZMP_OPASA_Q020
ZMP_OPASA_Q021
ZMP_OPASA_Q022
ZMP_OPASA_Q023
ZMP_OPASA_Q024
ZMP_OPASA_Q025
ZMP_OPASA_Q026
ZMP_OPASA_Q027
ZMP_OPASA_Q028
ZSDC_SSL_Q007
NEC Crystal Reports Standards Check
1. SA140 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA140 NEC CR checklist has been sent to NEC and also attached here for reference.
SA140 NEC CR Standard Check List.xlsx
Shipped + Open Sub Report Validation
Test Conducted
Grouping: Region > Sales Org > License
Group: North America > Canada Sales > MLB PROPERTIES
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Shipped YTD
|
1,618,109
|
1,618,109
|
Pass
|
2
|
Open YTD
|
223,682
|
223,682
|
Pass
|
3
|
Last Year Shipped YTD
|
1,749,177
|
1,749,177
|
Pass
|
4
|
Shipped Total Year
|
3,234,544
|
3,234,544
|
Pass
|
5
|
Open Total Year
|
3,489,796
|
3,489,796
|
Pass
|
6
|
Last Year Shipped Total
|
13,223,517
|
13,223,517
|
Pass
|
Hot Market Sub Report Validation
Test Conducted
Grouping: Region > Sales Org > License
Group: North America > UNITED STATES SALES > MLB PROPERTIES
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Shipped YTD
|
35,227
|
35,227
|
Pass
|
2
|
Open YTD
|
0
|
0
|
Pass
|
3
|
Last Year Shipped YTD
|
126,075
|
126,075
|
Pass
|
4
|
Shipped Total Year
|
19,482
|
19,482
|
Pass
|
5
|
Open Total Year
|
260
|
260
|
Pass
|
6
|
Last Year Shipped Total
|
8,050,675
|
8,050,675
|
Pass
|
Shipped Product Collections Report Validation
Test Conducted
Grouping: Region > Sales Org > License
Group: North America > UNITED STATES SALES > MLB PROPERTIES > AC PERFORMANCE
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity Current Year
|
675,253
|
675,253
|
Pass
|
2
|
Revenue Current Year
|
9,653,994
|
9,653,994
|
Pass
|
3
|
Quantity Last YTD
|
663,695
|
663,695
|
Pass
|
4
|
Revenue Last YTD
|
9,324,008
|
9,324,008
|
Pass
|
Open Product Collections Report Validation
Test Conducted
Grouping: Region > Sales Org > License
Group: North America > UNITED STATES SALES > MLB PROPERTIES > CUSTOM 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Quantity Current Year
|
367,573
|
367,573
|
Pass
|
2
|
Revenue Current Year
|
4,999,528
|
4,999,528
|
Pass
|
3
|
Quantity Last YTD
|
0
|
0
|
Pass
|
4
|
Revenue Last YTD
|
0
|
0
|
Pass
|
Shipped+Open Product Lines Report Validation
Test Conducted
Grouping: Region > Sales Org > License
Group: North America > UNITED STATES SALES > MLB PROPERTIES > HEADWEAR
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Shipped Qty Curr Year
|
3,827,522
|
3,827,522
|
Pass
|
2
|
Actual Rev Curr Year
|
49,363,665
|
49,363,665
|
Pass
|
3
|
Shipped Qty Prev YTD
|
2,393,873
|
2,393,873
|
Pass
|
4
|
Actual Rev Prev YTD
|
28,924,315
|
28,924,315
|
Pass
|
5
|
Open Qty Curr Year
|
2,888,991
|
2,888,991
|
Pass
|
6
|
Open Value Curr Year
|
35,324,405
|
35,324,405
|
Pass
|
7
|
Open Qty Prev YTD
|
0
|
0
|
Pass
|
8
|
Open Value Prev YTD
|
0
|
0
|
Pass
|
Shipped Product Styles Report Validation
Test Conducted
Grouping: Region > Sales Org > License
Group: North America > UNITED STATES SALES > MLB PROPERTIES > 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Shipped Quantity Current Year
|
2,270,468
|
2,270,468
|
Pass
|
2
|
Actual Revenue Current Year
|
34,689,364
|
34,689,364
|
Pass
|
3
|
Shipped Quantity Last YTD
|
1,373,550
|
1,373,550
|
Pass
|
4
|
Actual Revenue Last YTD
|
19,359,239
|
19,359,239
|
Pass
|
Open Product Styles Report Validation
Test Conducted
Grouping: Region > Sales Org > License
Group: North America > UNITED STATES SALES > MLB PROPERTIES > 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Open Quantity Current Year
|
1,671,648
|
1,671,648
|
Pass
|
2
|
Open Value Current Year
|
23,005,668
|
23,005,668
|
Pass
|
3
|
Open Quantity Last YTD
|
0
|
0
|
Pass
|
4
|
Open Value Last YTD
|
0
|
0
|
Pass
|
Shipped Product Styles Report Validation
Test Conducted
Grouping: Region > Sales Org > License
Group: North America > UNITED STATES SALES > MLB PROPERTIES > Lids Inc
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Shipped Quantity Current Year
|
1,339,016
|
1,339,016
|
Pass
|
2
|
Actual Revenue Current Year
|
18,343,736
|
18,343,736
|
Pass
|
3
|
Shipped Quantity Prev YTD
|
631,444
|
631,444
|
Pass
|
4
|
Actual Revenue Prev YTD
|
8,347,316
|
8,347,316
|
Pass
|
Service Level Report Validation
Test Conducted
Grouping: Region > Sales Org > License
Group: North America > UNITED STATES SALES > MLB PROPERTIES
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ordered Ontime Curr Year
|
84%
|
84%
|
Pass
|
2
|
Ordered Fill Rate Curr Year
|
92%
|
92%
|
Pass
|
3
|
Confirmed Ontime Curr Year
|
91%
|
91%
|
Pass
|
4
|
Confirmed Fill Curr Year
|
96%
|
96%
|
Pass
|
5
|
First Pass Curr Year
|
89%
|
89%
|
Pass
|
6
|
Ordered Ontime Prev Year
|
87%
|
87%
|
Pass
|
7
|
Ordered Fill Rate Curr Year
|
97%
|
97%
|
Pass
|
8
|
Confirmed Ontime Curr Year
|
94%
|
94%
|
Pass
|
9
|
Confirmed Fill Curr Year
|
100%
|
100%
|
Pass
|
10
|
First Pass Prev Year
|
97%
|
97%
|
Pass
|
Reference Document (Specification)
2013-03-15 - 5910.200 - Spec - Contract Reports